package com.uh.summary.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.uh.summary.dto.QueryInDTO;
import com.uh.summary.dto.QueryOutDTO;
import com.uh.calculation.bean.WarnEnterpriseRecord;
import com.uh.summary.enums.TableNameEnum;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface WarnEnterpriseRecordMapper extends BaseMapper<WarnEnterpriseRecord> {
    QueryOutDTO getColumns(QueryInDTO dto, String periodYear, String periodMonth);

    Integer getMaxWarnCode();

    Integer getTabNum(@Param("tabname") String tabname);

    List<WarnEnterpriseRecord> getInvest(@Param("start") int start, @Param("offset")int offset,@Param("year") String year);

    List<WarnEnterpriseRecord> getTradeE(@Param("start") int start, @Param("offset")int offset,@Param("year") String year);

    List<WarnEnterpriseRecord> getTradeS(@Param("start") int start, @Param("offset")int offset,@Param("year") String year);

    List<WarnEnterpriseRecord> getService(@Param("start") int start, @Param("offset")int offset,@Param("year") String year);

    List<WarnEnterpriseRecord> getIndustrial(@Param("start") int start, @Param("offset")int offset,@Param("year") String year);

    List<String> getCompanyCodeStrings(String tbl, String column, int limit);

    int insertBatch(List<WarnEnterpriseRecord> res);

    List<WarnEnterpriseRecord> selectFrequencyBy(String tbl, String col);

    String selectStatIdBy(String year, String tbl);

    List<WarnEnterpriseRecord> selectSameIpBy(String tbl, String year);
}
